package com.apes.autoparts.supplier.inheart;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.apes.framework.query.ApesDao;
import org.springframework.stereotype.Component;

/**
 * Created by lishikun on 2021/4/20 15:15
 */
@Component
public class InHeartDao extends ApesDao {

    public JSONArray findInHearts(JSONObject param) {
        String sSQL = "SELECT A.ID,A.PJID, A.PJBRAND, A.PJFACTORY, A.PJCODE, A.PJNAME FROM IN_HEART A WHERE A.PJID IN :pjids " +
                " AND supplier_platform_item_id = :supplierPlatformItemId";
        return toJSONArray(find(sSQL, param));
    }
}
